LOAD DATA
INFILE "C:\Users\465916\Desktop\Database_assignment_2\Spearfish\res\payrollCSV.txt"
REPLACE
INTO TABLE payroll_load
FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(payroll_date DATE "Month dd, yyyy",employee_id,amount,status)